﻿

-----------------------------------------
---需求进展表  huangjj 20100121 begin
----
-- Create table
create table T_POC_REQ_PROGRESS
(
  ID_          VARCHAR2(32) not null,
  REQ_ID_      VARCHAR2(32),
  REQ_PROG_    VARCHAR2(4000),
  PERCENT_     VARCHAR2(32),
  CREATOR_     VARCHAR2(32),
  CREATE_TIME_ DATE
);

--- Add comments to the table 
comment on table T_POC_REQ_PROGRESS
  is '需求进展情况，对需求进展的描述内容，主要包括完成内容及完成百分比。';
---Add comments to the columns 
comment on column T_POC_REQ_PROGRESS.ID_
  is '唯一键';
comment on column T_POC_REQ_PROGRESS.REQ_ID_
  is '需求单号，需求单的唯一键';
comment on column T_POC_REQ_PROGRESS.REQ_PROG_
  is '情况描述。';
comment on column T_POC_REQ_PROGRESS.PERCENT_
  is '完成百分比';
comment on column T_POC_REQ_PROGRESS.CREATOR_
  is '创建人员';
comment on column T_POC_REQ_PROGRESS.CREATE_TIME_
  is '创建时间';

--需求进展附件

-- Create table
create table T_POC_REQ_PROG_ATTACH
(
  ID_      VARCHAR2(32) not null,
  PROG_ID_ VARCHAR2(32),
  CONTENT_ BLOB
);
-- Add comments to the table 
comment on table T_POC_REQ_PROG_ATTACH
  is '需求进展附件表';
  
--添加序列
insert into T_COMM_SEQUENCE values('SEQ_REQ_PROGRESS',1);
insert into T_COMM_SEQUENCE values('SEQ_REQ_PROG_ATTACH',1);
-- Add/modify columns 需求进展 流程步骤节点
alter table T_POC_REQ_PROGRESS add Config_Detail_ VARCHAR2(32);
-- Add comments to the columns 
comment on column T_POC_REQ_PROGRESS.Config_Detail_
  is '流程步骤节点';
  
--需求延迟
/*==============================================================*/
/* Table: T_POC_REQ_DELAY                                       */
/*==============================================================*/
create table T_POC_REQ_DELAY 
(
   ID_                  VARCHAR2(32)                   not null,
   REQ_ID_              VARCHAR2(32),
   DELAY_TIME_          VARCHAR2(32),
   DELAY_REASON_        VARCHAR2(4000),
   DELAY_PROD_          VARCHAR2(32),
   CREATOR_             VARCHAR2(32),
   CREATE_TIME_         DATE,
   ORI_VAL_             VARCHAR2(32),
   constraint PK_T_POC_REQ_DELAY primary key  (ID_)
);

comment on table T_POC_REQ_DELAY is 
'需求延迟表，记录延迟原因';

comment on column T_POC_REQ_DELAY.ID_ is 
'唯一键';

comment on column T_POC_REQ_DELAY.REQ_ID_ is 
'需求单号';

comment on column T_POC_REQ_DELAY.DELAY_TIME_ is 
'延迟时长';

comment on column T_POC_REQ_DELAY.DELAY_REASON_ is 
'延迟原因';

comment on column T_POC_REQ_DELAY.DELAY_PROD_ is 
'延迟流程节点';

comment on column T_POC_REQ_DELAY.CREATOR_ is 
'延迟申请人';

comment on column T_POC_REQ_DELAY.CREATE_TIME_ is 
'延迟提交时间';

comment on column T_POC_REQ_DELAY.ORI_VAL_ is 
'工作时限原值';

  insert into t_comm_sequence
  (name, next_val)
values
  ('SEQ_REQ_PROGRESS', 1);
insert into t_comm_sequence
  (name, next_val)
values
  ('SEQ_REQ_PROG_ATTACH', 1);
insert into t_comm_sequence
  (name, next_val)
values
  ('SEQ_REQ_DEPLAY', 1);
  
  
  -- Add/modify columns 进展信息关联历史记录表
-- Add/modify columns 
alter table T_POC_REQ_PROGRESS add RECOTD_ID VARCHAR2(32);
-- Add comments to the columns 
comment on column T_POC_REQ_PROGRESS.RECOTD_ID
  is '关联历史记录ID';
  
  
-- Add/modify columns 延迟信息关联历史记录表
alter table T_POC_REQ_DELAY add RECOTD_ID varchar2(32);
-- Add comments to the columns 
comment on column T_POC_REQ_DELAY.RECOTD_ID
  is '关联历史记录ID';
---需求进展表  huangjj 20100121 end
